LOAD DATA 
 INFILE microorganismos.dat
 TRUNCATE
 CONTINUEIF NEXT(1:1) = '#'
 INTO TABLE MICROORGANISMOS
 FIELDS TERMINATED BY '|'
 TRAILING NULLCOLS (
   OBJECTID,
   id_muestra,
   tipo 	NULLIF tipo = BLANKS,
   conteo,
   fecha,
   id_habitad,
   GEO COLUMN OBJECT 
   (
     SDO_GTYPE       INTEGER EXTERNAL, 
     SDO_POINT COLUMN OBJECT
       (X            FLOAT EXTERNAL, 
        Y            FLOAT EXTERNAL) 
   )
)
